﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using ERP.Manager.DataEntity;
using ERP.Manager.Core;
using ERP.Manager.DataHelper;
using ERP.Manager.DataProvider;
using System.Data;
using System.Data.SqlClient;
namespace ERP.Manager.SQLServerProvider
{
    public class ECS_order_infoRepository : IECS_order_infoRepository
    {
        #region 分页查询商品的订单信息
        public List<ECS_order_info> all_ecs_order_info_page()
        {
            List<ECS_order_info> list = new List<ECS_order_info>();
            SqlDataReader read = SQLHelper.ExecuteReader(CommandType.Text, ERPSQL.ALL_ECS_ORDER_INFO_PAGE);
            try
            {
                while (read.Read())
                {
                    ECS_order_info order = new ECS_order_info();
                    order.order_sn = read["order_sn"].ToString();
                    list.Add(order);
                }
                read.Close();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                read.Dispose();
            }
            return list;
        }

        #endregion
    }
}
